﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace DataAccessLayer {
    public class SanPhamRepository : DataProvider {
        /// <summary>
        /// get all products
        /// </summary>
        /// <returns></returns>
        public DataTable getProducts() {
            String sql = "SELECT  SanPham.MaSP, SanPham.TenSP, ChiPhiInAn.DonGia " +
                         " FROM ChiPhiInAn INNER JOIN SanPham ON ChiPhiInAn.MaSP = SanPham.MaSP";
            return this.executeQueryDataTable(sql);
        }
    }
}
